﻿CREATE TABLE [dbo].[dscGateway_Series] (
    [InstanceUID]                    VARCHAR (100) NOT NULL,
    [StudyInstanceUID]               VARCHAR (100) NOT NULL,
    [Modality]                       VARCHAR (50)  NOT NULL,
    [Description]                    VARCHAR (100) NOT NULL,
    [Number]                         INT           NULL,
    [NumberOfSeriesRelatedInstances] INT           NULL,
    CONSTRAINT [PK_dscGateway_Series] PRIMARY KEY CLUSTERED ([InstanceUID] ASC),
    CONSTRAINT [FK_dscGateway_Series_dscGateway_Study] FOREIGN KEY ([StudyInstanceUID]) REFERENCES [dbo].[dscGateway_Study] ([InstanceUID])
);

